1 DECLARE @
sql nvarchar(max),
4 SET @
sql = 'ALTER TABLE /*_*/archive DROP CONSTRAINT ';--
7 FROM sys.default_constraints df
9 ON c.object_id
= df.parent_object_id
10 AND c.column_id
= df.parent_column_id
12 df.parent_object_id
= OBJECT_ID('/*_*/archive')
13 AND ( c.
name = 'ar_text' OR c.
name = 'ar_flags' );--
15 SET @
sql = @
sql + @
id;--
17 EXEC sp_executesql @
sql;--
19 ALTER TABLE /*_*/archive
DROP COLUMN ar_text
;
20 ALTER TABLE /*_*/archive
DROP COLUMN ar_flags
;
21 ALTER TABLE /*_*/archive
ALTER COLUMN ar_text_id
INT NOT NULL CONSTRAINT DF_ar_text_id
DEFAULT 0;